package com.gy.boot.sql;

import com.gy.boot.ApplicationTest;
import com.gy.boot.common.dao.IDao;
import com.gy.boot.common.dao.IEntity;
import org.junit.Test;

import java.util.List;

/**
 * 修改台账数据
 * */
public class UpdateTZ extends ApplicationTest {

    @Test
    public void testTZ() {
        // 1. 获取这批员工
        // SELECT * FROM b_guarantee_book WHERE city = '攀枝花' AND `month` = 202101 AND DATE_FORMAT(create_time, '%Y-%m-%d') = '2021-01-29';
        List<IEntity> listTZNew = IDao.listS("UpdateTZMapper.listTZ", null);
        for (IEntity TZNew : listTZNew) {
            // 3. 查找原台账ID


            // 4. 将员工数据的支出单替换掉

        }
    }



}
